package com.kehutong.charge.dao;

import com.kehutong.charge.entity.ReceiptsStatistics;
import org.coraframework.orm.annotation.Dao;
import org.coraframework.orm.annotation.Mapper;
import org.coraframework.orm.jdbc.execute.Condition;

import java.util.List;

@Dao
public interface ReceiptOrdersDao {


	@Mapper(
			genericType = ReceiptsStatistics.class,
			sql= "select communityNo communityName,0 lastMonthNum,0 totalNum,DATE_FORMAT(createTime,'%Y-%m') monthTime," +
					"COUNT(id) monthlyNum,now() statistTime FROM t_charge_receipt_order WHERE ${}"
	)
	List<ReceiptsStatistics> statistic(Condition... condition);
}
